|
Oracle Database 11g R2 - Settings before Installation
2011/03/29 |
| Install Oracle Database 11g R2.
Desktop Environment is required because installation proceeds on GUI. Before Installing, Change some settings for requirement of installing Oracle. |
|
| [1] | Install some packages |
|
[root@db01 ~]# yum -y install binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel glibc glibc-common glibc-devel gcc gcc-c++ libaio libaio-devel libgcc libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel |
| [2] | Edit Kernel parameter. |
|
[root@db01 ~]# vi /etc/sysctl.conf # make it comment # net.bridge.bridge-nf-call-ip6tables = 0# net.bridge.bridge-nf-call-iptables = 0# net.bridge.bridge-nf-call-arptables = 0# add at the last line
net.ipv4.ip_local_port_range = 9000 65500 fs.file-max = 6815744 kernel.shmall = 10523004 kernel.shmmax = 6465333657 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 net.core.rmem_default=262144 net.core.wmem_default=262144 net.core.rmem_max=4194304 net.core.wmem_max=1048576 [root@db01 ~]# sysctl -p net.ipv4.ip_forward = 0 net.ipv4.conf.default.rp_filter = 1 net.ipv4.conf.default.accept_source_route = 0 kernel.sysrq = 0 kernel.core_uses_pid = 1 net.ipv4.tcp_syncookies = 1 net.ipv4.ip_local_port_range = 9000 65500 fs.file-max = 65536 kernel.shmall = 10523004 kernel.shmmax = 6465333657 kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 net.core.rmem_default = 262144 net.core.wmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_max = 1048576 |
| [3] | Create a user for Oracle. |
|
[root@db01 ~]# groupadd -g 200 oinstall [root@db01 ~]# groupadd -g 201 dba [root@db01 ~]# useradd -u 440 -g oinstall -G dba -d /usr/oracle oracle [root@db01 ~]# passwd oracle Changing password for user oracle. New UNIX password: Retype new UNIX password: passwd: all authentication tokens updated successfully. [root@db01 ~]# vi /etc/pam.d/login # near line 14: add session required pam_selinux.so open session required pam_namespace.so session required pam_limits.so session optional pam_keyinit.so force revoke session include system-auth -session optional pam_ck_connector.so [root@db01 ~]# vi /etc/security/limits.conf # add at the last line
oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 [root@db01 ~]# vi /etc/profile # add at the last line
if [ $USER = "oracle" ]; then if [ $SHELL = "/bin/ksh" ]; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi fi |
| [4] | Switch to a user "Oracle" and configure some settings. |
|
[oracle@db01 ~]$ chmod 755 /usr/oracle [oracle@db01 ~]$ mkdir /usr/oracle/app [oracle@db01 ~]$ chmod 775 /usr/oracle/app [oracle@db01 ~]$ mkdir /usr/oracle/oradata [oracle@db01 ~]$ chmod 775 /usr/oracle/oradata [oracle@db01 ~]$ vi ~/.bash_profile # add at the last line
umask 022 export ORACLE_BASE=/usr/oracle/app [oracle@db01 ~]$ mkdir tmp # create a temporary dir for installation |